SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490036 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490036 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656797,116675,587232,589206,605477,598986,223692,4394,641173,17356,976991,884741,999214,469766,7334,841034,985728,612308,254807,138243,952890,273272,194475,871885,373709,420887,2261,206898,78968,738795,417445,1045287,841707,276218,806200,928814,521263,598416,217664,124497,67512,731301,365779,291167,245826,340920,298245,44130,193267,150274,240641,326016,871691,365551,813728,429509,425450,423252,355151,8040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]