SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434103 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434103 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457597,421060,930212,541815,93363,675132,131058,659190,475637,701265,270854,86232,135634,4133,324448,318879,626645,223939,896783,464350,386289,59245,685525,408487,1021781,225549,932294,899091,375169,155621,489847,780640,513219,289780,1017765,193500,582912,160910,1036467,302736,419849,487445,819937,354932,802072,164098,230255,866055,178417,137646,274972,1022249,718327,327268,843191,1013033,731949,1027364,963893,880022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]