SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981584 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981584 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168778,80641,942248,342056,496930,16488,386855,387823,138530,605931,122936,401690,843887,520707,858592,516586,855994,1014208,402496,830445,318194,847,641378,920427,787526,683949,775380,82192,438771,491600,87728,937514,29028,3381,972980,893854,763974,318524,284123,921210,48849,852635,565776,105390,123196,112705,213343,373854,648441,548771,498335,955487,128066,713816,1007460,94453,611025,454963,935471,919673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]