SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980712 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980712 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894422,714845,73037,629690,475507,214377,593400,645103,569047,310908,449688,45367,378000,610127,380749,967272,872301,445487,258287,372905,448746,102049,674916,847027,497688,841948,265607,305386,24917,683883,901542,915353,566490,165912,570980,820541,281603,512247,381881,338778,374010,774287,458762,804099,232091,529623,901128,869983,310581,818337,519345,838723,1039114,807816,428134,949496,645437,968156,614402,997865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002440s ]