SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539939 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539939 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043236,1040357,5529,598098,1033765,162473,469544,294334,317353,300742,895536,154812,433535,884203,783399,670663,436334,298495,594347,624188,204511,544664,909193,996239,423750,26334,312797,387290,42252,602466,33754,501795,493670,1047704,183367,532475,276138,610928,995709,368810,359377,126525,121634,799372,782987,148890,65958,871442,296820,667244,1039138,769871,59604,1041866,943883,155086,882730,309689,497440,542872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]