SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819791 LIMIT 1 [ RunTime:0.001155s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819791 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110383,19115,415226,121621,25040,177346,938398,469389,748713,117173,801144,397070,271711,512351,795179,762688,513217,5491,539496,316761,27466,558877,156225,100778,170209,493543,276149,665823,258770,772271,597429,602529,846502,783370,8335,547119,99764,709662,3534,416613,762138,675308,709338,158031,144570,1018052,408150,285827,407244,726662,473570,682874,779988,642259,849465,544617,1042527,767005,822618,512144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]