SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286781 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286781 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79233,227282,111631,529142,791200,300947,127701,885406,293876,61653,690030,843047,973792,622324,413737,525004,128716,722085,3582,469729,795561,142088,855970,701216,291213,659553,317611,553665,238843,731347,465744,672149,1032179,922941,367791,626150,930008,609600,914193,548082,574287,581818,869401,1028143,991036,583956,800279,403219,1036904,179307,801155,950794,722378,768821,720077,37,342362,762607,309975,918560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001694s ]