SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54589 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54589 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980852,902519,319648,170372,783251,400797,318614,772203,312245,349655,655023,150341,430797,130657,79523,590474,636177,537065,494636,545850,199375,410749,402842,381073,688180,135092,109471,1039458,813320,604333,42118,252642,942719,1014868,600794,862981,75378,200673,197520,756929,585311,930964,367122,538510,848384,626393,475694,1009882,63353,73193,485659,542624,840378,595846,529055,80227,539108,171375,169546,9949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]