SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488099 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488099 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808907,312935,1030060,746732,905766,809538,217680,199325,765852,721353,106911,24484,455939,74003,481255,33207,345045,984187,738682,1003848,827719,989959,533225,957330,310416,559142,244582,259858,940858,948028,143970,999664,123651,434697,629763,1037276,882849,713873,365940,659163,234428,588363,11647,621593,771599,321478,645635,144408,730983,424852,771325,156152,377239,964394,309548,494228,53710,925881,583790,916419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]