SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198701 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198701 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391919,748061,180653,208551,404176,316621,905795,659626,818343,121223,888211,421946,835312,408055,107170,628577,154319,176052,915620,441817,111941,100280,102314,884059,36646,190038,595312,583128,810450,122902,531138,283641,536185,603132,32820,501809,69752,696548,299126,988417,816362,423518,133469,310551,226643,624737,430751,398754,890306,497198,400444,89145,815387,432955,645646,939195,249925,267536,916049,85626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]