SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104114 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104114 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24359,641111,979520,412063,680790,97969,438680,335581,316496,397872,349316,601930,1016796,200097,764595,788760,107276,449559,90433,742482,94845,532349,64987,455207,631326,404147,1003897,1046030,1005102,45138,51200,913858,139462,266564,1045438,703517,974345,599862,913186,851844,857214,475662,51887,952656,742098,391536,30923,722707,215194,636385,96171,657181,164519,648285,736792,27294,831943,954836,648898,817374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]