SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476826 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476826 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015410,48833,224699,57009,538270,18853,932277,182829,509741,990890,1013179,417727,949748,425580,990895,446327,410875,344069,353910,5294,714308,253161,1950,595049,995133,705014,180371,694983,999124,462618,294766,802736,167110,652989,334785,212570,561416,832882,146909,829785,953076,810672,17514,970708,658792,466478,150480,435073,413863,200263,304458,1004397,420811,1023762,390293,321392,111382,817776,743611,614671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002253s ]