SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032840 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032840 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570840,141612,194746,418037,108898,354346,8088,648350,220609,407348,537413,127463,804204,247212,278025,615525,751255,739418,247321,884016,527406,929718,542292,298543,163498,991093,799233,598017,96525,591143,451409,1006148,323159,72907,290081,382644,488797,224837,200062,217184,753035,790725,199169,595439,1025421,712961,576596,838505,448510,708410,239241,491699,398327,718922,501860,1006953,867108,83998,373609,950799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]