SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541153 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541153 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668882,934910,649639,933458,908125,33974,160678,711978,41198,234760,302133,745042,687145,622470,279454,380215,583666,293902,441625,380975,446097,937968,31277,671505,902864,178633,18062,952702,413739,621609,174729,281576,7178,168352,150483,100010,924194,684848,418275,109159,37168,625040,1044646,1006821,416501,178280,990700,792761,333534,339457,293701,699547,716999,309086,654206,542777,346931,181029,207310,86501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]