SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020195 LIMIT 1 [ RunTime:0.001761s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020195 [ RunTime:0.001399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982158,427530,669478,1036002,979229,569100,513153,357062,708727,346151,468861,113064,85161,154925,355773,227022,1042408,391699,280131,219608,776453,968574,56567,788304,29315,26240,93845,970747,379369,319593,42232,827980,89376,212886,1000474,743822,376790,481453,273677,1004305,801376,793440,642218,957678,693814,426928,805830,314865,996529,428864,614773,347748,815999,855623,9317,801999,398927,967006,306952,829257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]