SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42681 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42681 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339324,314410,926228,834147,307283,493000,380545,127602,450531,155925,225350,934675,880697,300413,437375,571838,1035671,961816,508450,391192,150744,828079,435076,287172,545835,1048365,990116,657750,982189,767064,917176,666567,956157,88026,636078,1011865,31381,316473,526595,939548,721800,925727,430375,245309,823321,946697,168221,505905,992969,423847,18855,811857,527841,68340,612814,600001,549085,784421,311779,47299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003927s ]