SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545313 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545313 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002539,935221,75017,79285,1019908,742198,53222,796868,861037,463069,94782,115368,377338,606802,50968,130912,786364,752544,836151,1395,974000,448195,16117,312590,113633,822728,429775,447027,78479,943251,780318,1028767,976122,811597,192279,37540,83847,559480,186178,901383,641128,1025419,508742,219989,710732,971375,316169,416740,193321,23692,436309,1015514,1007396,923177,305595,822432,557085,988427,590580,793399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]