SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439075 LIMIT 1 [ RunTime:0.002502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439075 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243696,574583,228730,555787,1021744,457232,263914,419310,715497,1033391,1024660,424246,817822,28929,636988,93440,34143,508559,697430,878483,337799,369722,100956,120213,946851,742461,474535,435231,340079,111151,399569,245312,177950,827085,662504,38430,614176,49888,264331,313663,3821,366602,678540,592351,455008,356296,462849,767441,752593,174364,434825,541261,768295,825695,483165,987150,71746,144892,462273,558247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003743s ]