SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430078 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430078 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912880,281981,545778,717149,20160,963292,923639,449240,403047,320860,451799,715807,764385,990048,506863,244331,739221,721965,954950,99682,77631,689434,74079,207746,395483,476582,148620,380960,26907,104056,376085,1025524,976271,482234,18178,797823,676103,362854,212896,214399,223653,233447,860123,222673,631356,333830,765439,970279,895711,730401,250979,459801,262724,1016881,739852,464959,395863,576455,17601,343262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]