SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38581 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38581 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12649,394984,131479,661385,22502,140947,1003091,390802,151679,770294,637329,529814,232028,182297,231289,1000351,284323,155188,49669,455763,257145,485488,1032721,268664,632430,914236,153856,400888,663853,456007,132386,621781,883444,1018269,939610,198055,222162,305544,312678,427936,920427,446220,644943,600526,195603,948655,254012,249158,787521,725539,789315,532570,176876,621771,820798,456693,826696,240956,48155,731892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]