SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109099 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109099 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671828,797046,805448,490263,123734,232209,275072,435305,471610,268921,17698,369102,278264,762457,518601,229423,353334,274548,27817,439497,951681,491758,529614,86137,468599,618684,472613,421366,881159,473700,938814,915516,743482,647140,657535,1033739,453696,1013374,1003890,712023,64429,790404,816924,454827,480351,827203,261004,65814,723144,87428,140030,123362,189069,258142,142316,863810,288427,369773,1012070,914589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]