SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160068 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160068 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343499,417418,331560,211171,506851,609820,479363,341729,490196,986896,244034,1002034,489171,1038741,206157,793399,589700,895326,135394,1002227,232062,854437,1030506,453891,242535,903953,328399,182949,539646,771952,361078,288209,1000246,605685,361124,124312,234334,43640,159370,216131,381638,662635,954114,514561,681451,815038,349247,38523,677818,76314,503343,679137,388960,170649,985682,580055,735218,819113,33949,829282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]