SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197440 LIMIT 1 [ RunTime:0.000820s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197440 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135477,624431,214808,49368,893238,248240,767112,732615,620698,987482,38621,502539,248475,536584,611728,626751,543035,665628,135870,894811,894518,134711,831989,73846,368297,78626,835051,607509,693277,793046,130478,95797,431112,896639,493872,651519,671214,595155,193773,831025,505025,230727,792996,502515,818886,743459,709058,596597,855903,458496,388682,595131,546314,403896,206981,333667,518360,333596,577682,856825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]