SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400368 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400368 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188071,1020522,679073,520032,279026,245488,597732,595787,305716,413265,7942,7978,283037,932292,793434,369435,207246,825652,495871,819076,176260,834915,65798,201722,778257,72583,327335,830409,557705,897817,859714,793421,569564,696668,875416,927924,797485,580811,366756,969165,681573,126293,709869,24007,162863,585193,661405,404951,713648,908013,303730,6162,374498,356897,210390,218047,60199,501430,540689,82310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]