SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565317 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565317 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523842,911260,442047,664615,363885,840873,410138,120503,611252,607148,720291,355987,439990,877468,229602,559798,588207,875029,407751,1035599,34654,549818,1014771,279114,828713,352613,357985,386068,342703,87966,600225,894200,97221,496819,904322,1002941,298651,920651,945386,588353,683423,575311,515573,587386,376157,659725,177709,863938,1023094,1037418,831773,600791,957537,995547,270773,669038,265973,947504,833245,128507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]