SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513893 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513893 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210336,791986,23059,228960,563325,333137,557401,798195,393229,218591,383515,619360,995949,93517,1028992,936567,825644,567986,687295,996072,637267,555116,477613,853191,707493,877684,970172,157755,79574,979517,428415,165621,290626,302559,1017849,588482,215102,934221,118673,683356,3473,338701,354139,841381,762558,262517,948398,787315,314617,445143,560112,383866,1021919,413584,558689,30843,692532,659027,914110,993718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]