SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497291 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497291 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454304,166910,1004966,651656,729252,874312,80067,535004,283997,1005795,752532,188105,740852,228577,206101,280567,317232,644109,95234,1007328,200604,768315,84900,634026,195993,978638,437975,828790,159141,552530,675298,274821,821926,706637,241945,138036,432035,95598,220545,618306,169111,149449,833187,849370,240385,99703,172716,764621,1032767,154428,191893,788056,863328,240146,515868,195428,677332,295333,214583,752801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]