SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526428 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526428 [ RunTime:0.003218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225637,804443,666415,1048301,958205,593565,76360,672792,150375,758660,227629,656477,654597,426651,275896,259922,823521,256360,4110,907127,849227,770357,599350,675098,1016086,586883,1014397,739352,548200,896533,898941,193866,604792,35284,912758,798850,343820,128064,1010205,461521,830139,22029,415027,228051,838493,701136,769127,260260,862729,308645,491057,722854,633722,913192,492758,459,172712,825298,570439,407721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]