SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529400 LIMIT 1 [ RunTime:0.000794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529400 [ RunTime:0.002981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595370,969740,224751,562981,1020395,862354,500337,594622,893812,180786,236114,228673,145983,297615,969889,208451,690390,183433,607723,831871,780920,130402,457521,109062,179585,117659,622218,419512,368862,139397,185339,566059,348380,97519,756122,839647,837251,426673,858963,404507,879179,556262,158693,51112,671857,660302,66748,18336,793462,809957,482550,125541,138561,835606,675981,737045,871213,883499,7476,169561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]