SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403928 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403928 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920247,527411,363270,768839,87459,620763,1021801,964813,554956,90179,801523,593319,392628,941033,318217,699752,775969,643754,304666,10416,401478,626127,697623,672235,38944,738805,785049,30303,94998,977050,34713,363841,295904,242309,960520,667546,55536,55074,255247,288012,536810,543430,710714,202673,337149,961284,149147,533318,682661,111940,617623,532866,494119,125047,381450,136311,653454,280571,109669,19513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]