SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429381 LIMIT 1 [ RunTime:0.002738s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429381 [ RunTime:0.004535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971760,348138,490599,445077,655537,768989,696519,417294,126473,1006515,311581,74859,69976,1037059,335047,890448,722878,990068,390599,640802,102385,39617,787534,38095,901738,984594,295785,440450,1000882,565193,42727,211718,695643,525622,335018,619920,542358,144776,728292,963201,200965,318580,277036,944823,686954,454200,648812,1010247,113000,627768,276788,383827,915198,33730,80494,254798,762272,77209,296064,357785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002586s ]