SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32080 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32080 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412627,971364,737102,203635,947072,65788,385800,679007,249525,767400,656270,540175,30862,137885,952595,429253,951258,44033,100405,853731,63340,467815,760651,337790,100070,695864,607867,1027059,259217,989565,814224,286329,206028,343818,921598,232106,132408,188713,22947,422117,987377,337075,339494,708701,639075,488979,191429,883233,596773,263647,99517,915779,610075,119132,379234,564474,313069,470447,599402,780156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]