SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67986 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67986 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293660,167278,293582,534439,253690,354203,589990,851219,227987,461392,497463,351165,1025524,3911,830354,341372,925098,1002630,166476,692803,304913,526812,971450,562367,107050,721602,245482,623029,1013374,195453,333988,282779,779750,513283,885483,244328,269982,153151,268768,343342,735708,31792,27342,434253,535795,617829,58116,1022730,374533,79239,206441,966845,512931,650809,791238,610583,221248,49963,528984,727693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]