SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042190 LIMIT 1 [ RunTime:0.000906s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042190 [ RunTime:0.004047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105027,251866,126442,518203,306558,943175,553252,36181,212179,648832,660345,865030,389079,342296,805513,620650,668389,577673,416672,288526,1035514,780800,198521,317624,670804,340497,440011,942397,895129,29279,539641,102528,966018,782703,543651,362854,599748,961410,399571,158744,870641,87240,684960,195293,828959,270807,1028261,141637,1001823,531683,870870,738385,631152,89903,50366,247806,516810,117199,956706,517388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]