SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841045 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841045 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742446,107680,642223,110519,273565,134519,127904,783713,1004296,895642,407723,1022947,259543,36679,102699,775566,532293,327134,170013,378643,197832,501784,243584,434836,640915,168208,11573,165177,441648,141712,439825,683962,916709,531938,256014,105350,844634,554281,34220,679494,70330,765365,497349,289640,457458,85188,601602,929448,744607,615234,732221,3355,579340,12299,843535,555999,330552,542566,212074,660683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]