SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584246 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584246 [ RunTime:0.003633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738902,461356,448653,720280,278342,891311,670163,880181,699947,189385,79131,280539,522673,1019228,979663,73487,992813,905564,39801,1030595,167502,564049,955236,673568,3913,226263,631271,717198,720674,271426,1001451,354966,209584,798020,433417,804048,167095,1048882,968003,983639,655764,1018505,781646,16077,18804,97283,344820,876980,776890,1038629,547828,901968,29538,539968,779767,678066,652013,294052,807187,267095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]