SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589036 LIMIT 1 [ RunTime:0.001725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589036 [ RunTime:0.003015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501263,76012,376670,460255,447883,810770,173188,880903,565975,1029395,404514,515146,961824,686030,364299,337990,361905,780882,119287,441412,73452,820608,173763,582197,356935,622989,716359,25918,512940,703810,450037,291036,207552,370273,740015,956131,480583,352049,100614,489814,806661,127239,532687,768760,35145,997848,71061,856789,923346,368660,692513,344934,17272,431345,741129,443665,333232,633350,109024,250279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]