SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644722 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644722 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387091,174198,894939,139160,1040802,987197,996037,244146,316736,17269,185887,166793,235300,197076,272520,249098,878386,459346,271298,470271,131989,674276,682833,226549,436100,712262,146040,335226,543635,454776,389784,302943,844879,910298,527321,11810,250968,659308,236740,140657,825877,590538,307627,1014604,670302,126382,660536,671087,328180,456087,951468,88423,801421,422586,296603,595543,829509,427490,833630,709318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001144s ]