SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534022 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534022 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680383,452031,401226,221879,199200,900034,65178,887435,496046,727419,942332,742897,730088,848761,966071,865528,89379,957065,839520,360947,461837,140073,902841,321084,49348,398209,820592,233624,152552,593060,767828,834221,818749,400133,179295,439852,457071,65281,263627,841245,486383,651798,42836,987074,657903,789868,506591,815237,676434,733989,359307,757298,12674,1026471,827749,943456,716689,928653,607982,52027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]