SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527201 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527201 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437460,50888,900989,523260,1018069,357552,694473,861768,470989,697417,611347,630329,1011790,31722,22922,350404,347948,729096,980608,831668,602669,856493,545010,107383,914366,976013,279064,884834,1012362,634328,676163,806641,523429,255053,793915,258187,108260,404965,1048591,93898,359947,130815,142633,587837,63841,532221,839089,709200,233211,889191,354523,201005,1048642,1013394,675122,970977,974963,97792,966697,454568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]