SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475023 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475023 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441124,971479,72189,803368,190333,363112,953562,183481,1024204,1034177,795373,142909,160315,986579,8194,519777,858720,1022197,564309,763330,93469,408947,318156,982584,580651,505221,397276,164944,724663,79753,519331,245443,378750,142952,942967,977837,941907,933554,574802,970182,651340,859752,706618,366859,595140,848403,365446,408917,1047742,363649,928622,358414,750355,735772,880632,261677,56270,1027287,75940,234039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]