SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512212 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512212 [ RunTime:0.009361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188415,695135,242367,572768,134774,20681,284682,970327,587193,794271,293780,1047489,559404,952999,195916,633363,661312,235008,89486,969659,531196,314305,192344,509336,417019,386486,206937,272556,342330,277228,483812,210521,358720,557173,337746,963290,653843,183893,1005523,329728,571384,99397,297898,222525,270061,198815,152744,539650,995381,560794,192645,235353,631560,195026,802545,413740,697055,382020,570693,567941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001580s ]