SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939160 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939160 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940508,396309,537464,734038,411217,115456,998942,506676,694905,1043852,201851,338159,801900,424549,381917,636246,647205,993241,751260,1019517,792674,795452,354704,557568,9412,637335,185590,958927,240125,317183,979343,400945,429223,862670,178499,566822,856401,799413,1003552,20073,79412,709920,313685,296784,1012468,315417,305420,613244,794420,246475,1026094,484721,627329,1015460,101094,99727,368401,11734,772168,693965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]