SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199909 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199909 [ RunTime:0.007008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336401,912752,934545,276634,732118,112102,910700,326973,713807,922703,138587,434005,36670,28197,620599,586312,961940,619664,730122,718510,428858,256106,319541,408885,58019,909226,973132,2592,954141,320299,1044700,971911,494106,998791,756038,189091,342650,775505,550464,595146,967877,87253,51992,577847,755232,849010,454210,776881,32073,1005419,763891,898672,502924,325719,867584,110966,920349,596615,403175,540364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]