SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423971 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423971 [ RunTime:0.003236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635801,855690,114101,150679,615617,929986,420904,371257,139090,397950,823389,587714,486217,883922,459327,978981,985144,599136,771550,450891,315324,660379,429292,487190,42454,864793,1033477,557369,1006703,90436,179344,778554,968808,410589,84032,136650,132298,288376,190558,773626,63757,512318,640542,628411,837346,151747,283148,46670,800709,435085,360981,228779,427917,290630,669675,247005,101829,299784,845311,866311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]