SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505108 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505108 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733970,235821,587763,365079,674651,674811,939015,654573,11234,980945,873306,119563,514771,980052,819980,982243,296678,693999,960822,437876,926852,1006396,795904,41121,232628,76534,294799,381594,191998,658719,335065,635255,751201,289604,164679,410491,751172,834616,861493,699915,724773,146445,344920,437766,308934,930757,23252,389706,924166,219846,601105,623999,476286,767685,133082,454343,829521,338161,122074,857956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]