SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520083 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520083 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177804,128009,956845,531009,862415,655312,665080,537434,445049,243239,107382,986675,78452,922742,48991,539871,1033906,611620,715719,983865,90623,180087,735281,359964,159164,874183,707396,593607,378452,411884,198330,331594,221770,763482,857604,86506,983056,605335,706623,541012,594039,19209,233114,979584,64786,229311,644235,741368,269077,943403,785294,424014,1024235,210616,424843,96735,39687,287739,106770,282430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]