SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549097 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549097 [ RunTime:0.001426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575886,115875,562741,90070,849694,705156,416350,400104,669442,1023195,190711,295281,387026,506659,121283,801293,301789,650156,852939,284284,100485,370969,798063,724923,742358,529947,382606,421896,618995,641292,307776,628558,839939,58699,633230,265595,423400,428572,278231,211311,334849,406181,889304,489647,870713,607767,407581,142399,169128,169113,540553,823039,492124,828708,266628,773781,977125,562205,926924,162238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]