SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510194 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510194 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954899,897528,835583,475480,1031883,452527,336454,712965,88529,806435,777427,674227,873875,848413,129274,490773,456069,622759,45547,122421,302797,881842,901460,257094,78559,80713,368688,578239,3821,948078,980147,944442,161330,704273,737070,640956,278523,536233,209322,788935,1020793,73022,916920,1026859,685148,518196,252152,60443,828707,958381,1002319,241564,10170,781758,567942,386406,790578,667968,757717,136709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]