SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349571 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349571 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665620,998455,518186,353387,10201,771308,319903,341392,960851,1038181,1013410,508498,591160,611544,805033,5633,225744,543856,754938,873442,946679,544934,786375,143457,532291,665132,1012844,984935,277044,402348,81935,80486,87211,799469,363118,500080,590080,34857,650790,305995,638069,403354,353006,977301,354420,105383,151455,366042,1020976,201562,103824,240236,345281,952187,321471,258258,1020753,62764,5535,832280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]