SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109908 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109908 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960900,1022869,212821,597497,286414,537718,87594,897001,487619,9707,917104,4089,902628,310119,475375,899931,764550,40907,208424,945611,757699,335400,841394,455114,735602,676675,645123,413229,201912,697638,441842,367511,471761,1018577,818679,5671,903423,550645,1039966,757743,532645,404424,939731,341852,617953,193214,570454,237418,604022,276475,381656,68965,5197,794847,99314,804395,87613,644817,54645,907480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]