SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48179 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48179 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3190,705260,256871,563141,343741,233782,257114,719191,142869,356493,879846,742094,843527,1046520,570821,191983,847332,488649,6588,558051,437086,509383,316390,986896,499668,929585,888153,355290,492872,890450,1005502,584196,950777,1027731,687532,299159,1011157,39100,121977,213926,362150,545132,628909,77540,1036648,641802,823044,198787,92106,937116,740451,322660,124700,140067,781078,770167,637983,183422,191077,259711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]