SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305142 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305142 [ RunTime:0.003511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504816,666946,949923,680184,288512,356488,833461,678583,129760,964121,106596,666219,184645,865253,177552,944256,300399,491505,377151,368457,468855,562376,348166,223221,606585,162889,339588,216990,992169,1019758,1012261,133071,176729,879478,652523,675969,631632,430173,170938,808046,771637,59017,1026448,473733,327545,900864,811172,945056,237974,238469,813250,113682,345065,167983,303160,497440,157247,375458,737451,165763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]