SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201551 LIMIT 1 [ RunTime:0.002621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201551 [ RunTime:0.005810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217144,1025368,1032027,418894,249536,584607,377777,490472,746912,870745,137794,634473,67401,688021,646530,118477,608592,584189,237997,311920,1045592,839335,988567,1024252,383304,105674,401823,335322,150624,673094,1006150,401956,520421,472342,102271,441846,336740,689361,250219,542941,424004,840454,928976,272980,420996,900559,1028987,39809,258411,40322,565205,471271,910420,586209,531601,580847,894667,651350,378523,885362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001133s ]