SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402394 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402394 [ RunTime:0.002856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436478,1028804,879792,246590,726147,993572,246608,624680,569537,914506,572386,754729,746413,850085,661109,499647,583211,619477,685896,576040,643977,498868,636910,414814,402141,952935,1006718,260960,42405,28236,439072,200084,337120,200322,885184,448024,250,74732,1031106,757446,369776,760587,435646,504504,950742,818976,351847,16937,273439,780224,453752,494807,306995,798771,844996,671515,907309,442066,577871,916111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]