SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 176113 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 176113 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435712,235930,115058,338177,193288,916427,72087,239123,1001909,705604,580572,937024,361106,685158,614210,291897,375311,256184,972994,698533,1012570,460457,549012,819690,600197,308653,759667,273697,362739,494990,552552,962203,547015,979669,130507,898565,606737,681871,141604,657302,1043195,692482,438644,551479,198873,1027388,222644,871288,273826,748967,692014,487092,91765,156615,836440,115547,105858,144589,237454,907728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 176113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 176113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]