SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406528 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406528 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130457,20440,601047,874921,459148,689157,410476,120648,97315,494639,545033,694431,79480,839487,1007788,581176,576424,169927,93276,905946,543466,1018836,481910,577279,700709,758119,122619,354000,883986,68216,179037,410631,529283,939197,662382,354608,823080,510552,11661,248545,395623,511715,497535,890763,477059,252564,288628,910692,725604,923071,103736,690298,406890,222956,910005,975082,544514,1000849,216140,867247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]