SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020474 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020474 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983514,149728,616224,130498,53183,188683,92091,259844,403180,230827,405568,68654,377521,60963,37785,860426,429685,1012553,15215,155245,871766,940109,275630,1031469,90818,567101,439811,256276,315337,978727,393949,681597,491921,26948,721543,291758,582222,531999,521698,622230,274086,432846,701393,704478,655172,1039289,905478,683696,704441,932504,490646,465020,508138,6394,200168,480930,421304,932428,408865,977579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]