SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019330 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019330 [ RunTime:0.005701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503623,528041,968022,236759,139604,798345,588044,908065,892122,758364,238720,48386,1043972,671750,361672,45697,39636,585303,17459,914159,500232,111970,148072,145896,107648,409555,226741,718609,12610,496035,287845,395871,830463,763058,238093,556365,261227,740767,475597,433623,931057,503470,556837,583467,402054,317788,452046,260456,871322,449388,445400,399041,214328,287455,429344,979903,22913,380048,823094,733561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]