SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 379528 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379528 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42472,222610,228497,989358,220753,1031800,579682,791062,444223,604945,1026134,722510,876073,765359,250505,291993,669775,531489,968444,772759,299064,498024,82796,955409,968889,204989,418231,676692,462091,86290,632216,1006558,490803,321050,712405,502451,610031,831073,33532,460737,334569,23021,372289,219046,675133,914560,571264,505727,723979,833653,964253,489370,892670,1008510,882089,671916,719081,676868,471150,977140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]