SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50281 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50281 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444532,632442,1036244,373187,343319,895746,795309,145860,558862,731238,38025,561932,24072,694180,811009,755173,746044,671672,368657,892107,242540,472774,649082,781545,804427,328395,548757,350165,337596,47521,508667,1022308,599016,513389,475287,425068,177324,977631,826464,453409,916303,342672,685334,887989,985273,592220,601290,115981,293241,206634,495455,188223,736551,704886,297754,614049,333838,931004,966797,1004785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]