SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432003 LIMIT 1 [ RunTime:0.006463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432003 [ RunTime:0.005767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454292,101027,236184,734299,514955,402977,747393,14237,154921,847108,120054,836497,69182,924372,854628,342656,118155,338139,572675,965672,471198,622317,244106,133861,184912,749784,467073,200366,963651,767882,614418,574801,651762,433508,837817,741207,683809,868267,769150,154204,227008,470033,510673,184424,514217,973377,630799,832796,47053,129941,719018,184819,960002,466836,603872,238831,244595,66300,304137,941268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001781s ]